﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DrugStorehouseMIS.DAL.Interface
{
    public interface IDrugDAL
    {
        IDataReader Select(int DrugNum);

        DataTable Select();

        DataTable Select(string DrugTypeName, string TradeName, string DrugCode);

        DataTable Select(string DrugType, string trade_name, string common_name, string drug_code);

        int Insert(string DrugTypeNum, string DrugTradeName, string DrugCommonName, string UserDefinedName, string DrugCode, string Specifications, string MeasuringUnitNum, string ApprovalNum, int max, int min, float tradeprice, float retail_price);

        int Update(int DrugNum, string DrugTypeName, string TradeName, string CommonName, string UserDefinedName, string DrugCode, string Specifications, string MeasuringUnitName, string ApprovalNum, int max, int min, float tradeprice, float retail_price);


        #region 灼林的
        //int Insert(int DrugTypeNum,string DrugTradeName,string DrugCommonName,string UserDefinedName,string DrugCode,string Specifications,int MeasuringUnitNum,string ApprovalNum,int MinQuantity,int MaxQuantity,float TradePrice,float RetailPrice);

        //int Update(int DrugNum, int DrugTypeNum, string DrugTradeName, string DrugCommonName, string UserDefinedName, string DrugCode, string Specifications, int MeasuringUnitNum, string ApprovalNum, int MinQuantity, int MaxQuantity, float TradePrice, float RetailPrice);
#endregion

        int Delete(int DrugNum);
    }
}
